package com.scs.application.modules.base.enums;

import com.scs.application.core.dto.ExcelImportField;

import java.util.ArrayList;
import java.util.List;

public class ExcelImportBaseDataConfig {
    public static List<ExcelImportField>  getMatrDataSplit() {
        List<ExcelImportField> exportHeadList = new ArrayList<ExcelImportField>();
        ExcelImportField headDTO;

        headDTO = new ExcelImportField();
        headDTO.setName("supplierName").setText("供应商名称").setCellIndex(0).setRequired(true).setMaxLength(150);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        headDTO.setName("name").setText("商品名称").setCellIndex(1).setRequired(true).setMaxLength(150);
        exportHeadList.add(headDTO);


        headDTO = new ExcelImportField();
        headDTO.setName("spec").setText("商品规格").setCellIndex(2).setRequired(true).setMaxLength(50);
        exportHeadList.add(headDTO);


        headDTO = new ExcelImportField();
        headDTO.setName("remark").setText("备注").setCellIndex(3).setMaxLength(50);
        exportHeadList.add(headDTO);
        return exportHeadList;
    }

    // 导入商品excel
    public static List<ExcelImportField>  getMatrDataImport() {
        List<ExcelImportField> exportHeadList = new ArrayList<ExcelImportField>();
        ExcelImportField headDTO;

        int index = 0;
        headDTO = new ExcelImportField();
        headDTO.setName("name").setText("商品名称").setCellIndex(index).setRequired(true).setMaxLength(300);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("supplierName").setText("供应商名称").setCellIndex(index).setRequired(true).setMaxLength(100);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("spec").setText("商品规格").setCellIndex(index).setRequired(true).setMaxLength(200);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("skuUnit").setText("单品单位").setCellIndex(index).setRequired(true).setMaxLength(10);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("skuPrice").setText("单品单价").setCellIndex(index).setRequired(true).setMaxLength(14).setNumber(true);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("mfgName").setText("生产厂家").setCellIndex(index).setRequired(true).setMaxLength(100);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("flagHigh").setText("是否高耗").setCellIndex(index).setRequired(true).setMaxLength(4).setNumber(true);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("hisMedicareName2").setText("医保名称").setCellIndex(index).setRequired(false).setMaxLength(100);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("hisMedicareNo").setText("医保代码20位").setCellIndex(index).setRequired(false).setMaxLength(50);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("hisMedicareNo2").setText("医保代码27位").setCellIndex(index).setRequired(false).setMaxLength(50);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("certificateNo").setText("注册证号").setCellIndex(index).setRequired(false).setMaxLength(50);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("certificateBegin").setText("注册证起").setCellIndex(index).setRequired(false).setMaxLength(20).setDate(true);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("certificateExp").setText("注册证止").setCellIndex(index).setRequired(false).setMaxLength(20).setDate(true);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("bidno").setText("中标号").setCellIndex(index).setRequired(false).setMaxLength(50);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("udi").setText("UDI-DI").setCellIndex(index).setRequired(false).setMaxLength(100);
        exportHeadList.add(headDTO);

        headDTO = new ExcelImportField();
        index++;
        headDTO.setName("categoryName").setText("管理分类").setCellIndex(index).setRequired(false).setMaxLength(50);
        exportHeadList.add(headDTO);


        return exportHeadList;
    }
    public static List<ExcelImportField>  getImportStock() {
        List<ExcelImportField> exportHeadList = new ArrayList<ExcelImportField>();
        ExcelImportField headDTO;
        int index = 0;
        headDTO = new ExcelImportField();
        headDTO.setName("warehouseName").setText("入库仓库").setCellIndex(index).setRequired(true).setMaxLength(150);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("supplierName").setText("供应商名称").setCellIndex(index).setRequired(true).setMaxLength(150);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("matrName").setText("商品名称").setCellIndex(index).setRequired(true).setMaxLength(150);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("matrSpec").setText("商品规格").setCellIndex(index).setRequired(true).setMaxLength(150);
        exportHeadList.add(headDTO);


        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("skuUnit").setText("单品单位").setCellIndex(index).setRequired(true).setMaxLength(50);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("skuPrice").setText("单品价格").setCellIndex(index).setRequired(true).setMaxLength(50).setNumber(true);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("skuQty").setText("单品数量").setCellIndex(index).setRequired(true).setMaxLength(50).setNumber(true);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("expDate").setText("效期").setCellIndex(index).setRequired(false).setMaxLength(50).setDate(true);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("mfgDate").setText("生产日期").setCellIndex(index).setRequired(false).setMaxLength(50).setDate(true);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("lot").setText("批号").setCellIndex(index).setRequired(false).setMaxLength(50);
        exportHeadList.add(headDTO);

        index++;
        headDTO = new ExcelImportField();
        headDTO.setName("mfgName").setText("生产厂商").setCellIndex(index).setRequired(false).setMaxLength(50);
        exportHeadList.add(headDTO);

        return exportHeadList;
    }
}
